package com.ruoyi.xuexiao.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.xuexiao.domain.entity.KsTc;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * 矿山图层管理数据层
 * @author 窦凯欣
 */
@Mapper
public interface KsTcxMapper extends BaseMapper<KsTc>
{
    /**
     * 添加数据
     * @param ksTc
     * @author 窦凯欣
     */
    @Insert("INSERT INTO ks_tc (xkzh, year, month, lon, lat, geom, wtlx, zdfs, kczt, zdmj, dt) VALUES(#{xkzh}, #{year}, #{month}, #{lon}, #{lat}, ST_GeomFromText(#{geom}), #{wtlx}, #{zdfs}, #{kczt}, #{zdmj}, #{dt})")
    void addData(KsTc ksTc);
}
